package com.wl.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.wl.entity.Warehouse_06;

public interface Warehouse_06Mapper {
	public int deleteByPrimaryKey(Integer id);

	public int insert(Warehouse_06 record);

	/**
	 * 动态sql语句添加入库业务信息
	 * 
	 * @param record
	 * @return
	 */
	public int insertSelective(Warehouse_06 record);

	public Warehouse_06 selectByPrimaryKey(Integer id);

	/**
	 * 根据flowid动态修改
	 * 
	 * @param record
	 * @return
	 */
	public int updateByPrimaryKeySelective(Warehouse_06 record);

	public int updateByPrimaryKey(Warehouse_06 record);

	/**
	 * 分页+按照处理人编号查询当前未处理业务
	 * 
	 * @param start
	 * @param limit
	 * @param keywords
	 * @return
	 */
	public List<Warehouse_06> selectWarehouseByAppno(@Param("start") int start, @Param("pageSize") int limit,
			@Param("appno") String appno);

	/**
	 * 查询得到该处理人当前未处理业务数
	 * 
	 * @param appno
	 * @return
	 */
	public int selectWarehouseByAppnoCount(@Param("appno") String appno);

	/**
	 * 分页+动态查找业务
	 * 
	 * @param start
	 * @param limit
	 * @param warehouse
	 * @return
	 */
	public List<Warehouse_06> selectWarehouseByPage(@Param("start") int start, @Param("pageSize") int limit,
			@Param("flowid") String flowid, @Param("appno") String appno, @Param("appresult") String appresult,
			@Param("starttime") String starttime, @Param("endtime") String endtime,
			@Param("appstatus") Integer appstatus, @Param("applyno") String applyno);

	/**
	 * 分页+动态查找的业务总数
	 * 
	 * @param warehouse
	 * @return
	 */
	public int selectWarehouseByPageCount(@Param("flowid") String flowid, @Param("appno") String appno,
			@Param("appresult") String appresult, @Param("starttime") String starttime,
			@Param("endtime") String endtime, @Param("appstatus") Integer appstatus, @Param("applyno") String applyno);

	/**
	 * 根据flowid查找业务记录
	 * 
	 * @param flowid
	 * @return
	 */
	public Warehouse_06 selectByFlowid(@Param("flowid") String flowid);
}